﻿IF EXISTS (SELECT * FROM information_schema.ROUTINES WHERE ROUTINE_TYPE = 'PROCEDURE' AND ROUTINE_NAME = 'OTEstadoGet')
	BEGIN
		DROP  Procedure  OTEstadoGet
	END
GO

CREATE PROCEDURE OTEstadoGet	
AS
BEGIN	
	SET NOCOUNT ON

	SELECT Id, Estado AS Nombre
	FROM Lit_Estado
	
	SET NOCOUNT OFF
END

GO 